Motivation

The report is developed to shed light on ethanol exports from Pakistan beginning year 2017.

Everything below is the result of computations performed on Ethanol Exports Database by computer program and displayed in the form of tables and charts. Where Microsoft Excel Dashboards have their weaknesses See Here and Microsoft Access reports are limited to desktops See Here,this method of reporting is not plagued by these weaknesses. Unlike Excel here the accuracy and consistency is guaranteed every time and reports can be constructed in an instant. With passing time I plan to make this more effective by adding some of my own insights to this and ensure that overall everything makes sense.

All prices of ethanol are in US Dollar on per metric ton basis indicated as M.Tons (Metric Tons).

  • Total observations from 2017 till date as below
    Observations
    9066

Year Wise Summary

Ethanol Summary Year Wise
Year Observations Percent Contribution (%) Value in Mil.USD Qty in M.Tons
2021 1060 11.69 246.23 273218.9
2020 2169 23.92 262.68 303117.4
2019 2157 23.79 257.12 375839.8
2018 2015 22.23 371.37 552463.8
2017 1665 18.37 378.95 565612.6

Storage Wise Summary

Ethanol Summary by Mode of Shipment
Storage Type Observations Percent Contribution(%) Value in Mil.USD Qty in M.Tons
SMALL PACK 8111 89.47 398.15 480799
BULK 955 10.53 1118.20 1589453

Product Wise Summary

Ethanol Summary by Product
Product Observations Percent Contribution (%) Value in Mil.USD Qty in M.Tons Max M.Ton Price Min M.Ton Price Mean M.Ton Price Median M.Ton Price
ENA 96% 5234 57.73 994.99 1315676.25 3379.13 465.00 862.08 832.62
B-Grade (94.5%-92.5%) 3037 33.50 398.97 579593.47 1015.88 370.50 737.69 731.12
Anhydrous 99% 622 6.86 22.24 25815.86 2043.00 665.00 882.46 823.69
Hydrous 95.8% 173 1.91 100.14 149166.86 1523.38 534.25 714.47 655.00

Regionwise Summary

Ethanol Summary by Region
REGION Obs Percentage Contribution(%) Value in Mil.USD Qty in M.Tons Max.M.Ton Price Min.M.Ton Price Mean M.Ton Price Median M.Ton Price
ASIA 5125 56.53 875.22 1258138.04 1891.37 370.50 767.65 730.00
AFRICA 1922 21.20 139.64 164741.64 1451.13 598.00 853.65 853.88
MIDDLE EAST 1480 16.32 107.28 112666.62 3379.13 500.00 969.00 896.00
EUROPE 443 4.89 391.65 531924.66 1685.00 487.50 748.99 690.00
AUSTRALIA 86 0.95 2.05 2342.81 1550.00 550.00 861.22 900.00
AMERICA 10 0.11 0.51 438.66 1867.87 720.38 1011.89 907.88

1. Trend Analysis

Summary

2. Analysis by Product

Data Distribution

  • The following table shows total product distribution
    No. of Observations
    Product Observation
    ENA 96% 5234
    B-Grade (94.5%-92.5%) 3037
    Anhydrous 99% 622
    Hydrous 95.8% 173
  • The following table shows product distribution by year
    No. of Observations
    Year ENA 96% B-Grade (94.5%-92.5%) Anhydrous 99% Hydrous 95.8%
    2021 927 64 55 14
    2020 1354 676 94 45
    2019 1169 787 164 37
    2018 899 881 194 41
    2017 885 629 115 36
  • The following table shows product distribution by storage
    No. of Observations
    Product SMALL PACK BULK
    ENA 96% 4603 631
    B-Grade (94.5%-92.5%) 2809 228
    Anhydrous 99% 620 2
    Hydrous 95.8% 79 94
  • The following table shows product distribution by regions
    No. of Observations
    REGION ENA 96% B-Grade (94.5%-92.5%) Anhydrous 99% Hydrous 95.8%
    ASIA 2889 1665 433 138
    AFRICA 1003 914 NA 5
    MIDDLE EAST 946 342 178 14
    EUROPE 334 91 2 16
    AUSTRALIA 54 24 8 NA
    AMERICA 8 1 1 NA
  • The major contribution of exports from Pakistan are due to countries in
    REGION
    ASIA
  • Among all regions in the world following has some of the highest prices overall
    REGION
    MIDDLE EAST

Product Wise Details Available Here

Values in Million USD.

Value in Mil. USD
Product 2021 2020 2019 2018 2017
ENA 96% 219.69 191.40 158.02 209.30 216.58
B-Grade (94.5%-92.5%) 13.91 57.14 77.32 124.40 126.20
Hydrous 95.8% 9.58 10.16 15.23 32.37 32.80
Anhydrous 99% 3.05 3.98 6.54 5.30 3.37

Quantity in M.Ton(Thousands)

Quantity in Thousand M.Ton
Product 2021 2020 2019 2018 2017
ENA 96% 916.71 1412.66 878.68 645.56 658.53
Anhydrous 99% 59.40 95.82 135.95 160.14 97.58
B-Grade (94.5%-92.5%) 45.78 531.46 580.93 639.24 442.95
Hydrous 95.8% 11.95 39.94 23.75 25.62 22.34

Data Distribution

  • The following table shows distribution of product over years
    No. of Observations
    Product 2017 2018 2019 2020 2021
    ENA 96% 885 899 1169 1354 927
    B-Grade (94.5%-92.5%) 629 881 787 676 64
    Anhydrous 99% 115 194 164 94 55
    Hydrous 95.8% 36 41 37 45 14

Plot

The plot below indicates price ranges of ethanol products over years.

For Price Outlier Details Click Here

3. Analysis by Region

Data Distribution

  • The following table shows total region distribution
    No. of Observations
    REGION Observation
    ASIA 5125
    AFRICA 1922
    MIDDLE EAST 1480
    EUROPE 443
    AUSTRALIA 86
    AMERICA 10
  • The following table shows distribution of regions by year
    No. of Observations
    Year ASIA MIDDLE EAST EUROPE AFRICA AUSTRALIA AMERICA
    2021 719 202 75 43 21 NA
    2020 1026 587 131 393 28 4
    2019 1131 291 70 645 16 4
    2018 1209 240 82 474 9 1
    2017 1040 160 85 367 12 1
  • The following table shows region distribution by storage
    No. of Observations
    REGION SMALL PACK BULK
    ASIA 4565 560
    AFRICA 1908 14
    MIDDLE EAST 1437 43
    EUROPE 105 338
    AUSTRALIA 86 NA
    AMERICA 10 NA
  • The following table shows distribution of regions by product
    No. Of Observation
    Product ASIA AFRICA MIDDLE EAST EUROPE AUSTRALIA AMERICA
    ENA 96% 2889 1003 946 334 54 8
    B-Grade (94.5%-92.5%) 1665 914 342 91 24 1
    Anhydrous 99% 433 NA 178 2 8 1
    Hydrous 95.8% 138 5 14 16 NA NA
  • Highest prices can be seen from the graph below
    Product
    ENA 96%

Values in Million USD.

Value in Mil. USD
REGION 2021 2020 2019 2018 2017
ASIA 141.82 88.08 134.32 250.99 260.00
EUROPE 88.74 89.25 62.58 74.28 76.79
MIDDLE EAST 10.79 54.14 15.56 12.59 14.20
AFRICA 4.04 30.02 44.41 33.38 27.79
AUSTRALIA 0.83 0.76 0.20 0.11 0.15
AMERICA NA 0.43 0.05 0.01 0.01

Quantity in M.Ton(Thousands)

Quantity in Thousand M.Ton
REGION 2021 2020 2019 2018 2017
ASIA 678.22 896.84 794.05 839.72 725.35
MIDDLE EAST 219.57 690.70 220.08 180.87 122.89
EUROPE 69.47 104.11 47.35 54.79 56.07
AFRICA 46.22 359.57 541.77 387.41 305.73
AUSTRALIA 20.35 23.81 12.62 6.78 10.49
AMERICA NA 4.84 3.44 0.97 0.87

Regionwise Details Available Here

Data Distribution

  • The following tables shows distribution of Regions over years
    No.of Observation
    REGION 2017 2018 2019 2020 2021
    ASIA 1040 1209 1131 1026 719
    AFRICA 367 474 645 393 43
    MIDDLE EAST 160 240 291 587 202
    EUROPE 85 82 70 131 75
    AUSTRALIA 12 9 16 28 21
    AMERICA 1 1 4 4 NA

Plot

The plot below indicates price ranges of Regions over years.

For Price Outlier Details Click Here

4. Country wise Analysis

Plot

The prices in “M.Tons (Metric Tons)” are plotted with respect to time for all countries as below.

For Interactive Plot Click Here

Data Distribution

  • Countries Available For Analysis
    Count
    66
  • The following are the country wise contributions by year
  • The following are the country wise contributions by Product
  • The following are the country wise contributions by Storage

5. Exporter wise Analysis

  • Total Exporters Available For Analysis
    Count
    22

Plot

The plot below indicates price ranges of Exporters over years.

For Price Outlier Details Click Here

Data Distribution

  • The following is the exporter wise contribution by Year
  • The following are the exporter wise contributions by Product
  • The following are the exporter wise contributions by Storage

6. Importer wise Analysis

Importer Details Available Here

  • Total Importers Available For Analysis
    Observations
    309

Importerwise Summary